
IF NOT EXISTS(SELECT 1 FROM sys.tables AS t (NOLOCK) INNER JOIN sys.columns AS c (NOLOCK) ON c.object_id = t.object_id WHERE t.name = 'yt_tapd_story' AND c.name = 'xShortID')
BEGIN
		ALTER TABLE dbo.yt_tapd_story ADD xShortID  AS ([sID]%(10000000))
END
GO


---- [xShortID] AS ([sID]%(10000000)),
--SELECT ([sID]%(10000000)), * FROM dbo.yt_tapd_story AS ts

--SELECT * FROM dbo.yt_tapd_task AS tt


